from sqlalchemy import Table, Column, INTEGER, String, BIGINT
from db.basic_db import metadata

weibo_data = Table('weibo_data', metadata,
                   Column("id", INTEGER, primary_key=True, autoincrement=True),# 内容D
                   Column("weibo_id", String(200), unique=True),# 微博ID
                   Column("weibo_cont", String(6000), default='', server_default=''),# 微博内容
                   Column("repost_num", INTEGER, default=0, server_default='0'),# 转发数
                   Column("comment_num", INTEGER, default=0, server_default='0'),# 评论数
                   Column("praise_num", INTEGER, default=0, server_default='0'),# 点赞数
                   Column("uid", String(20)),# UID
                   # Column("is_origin", INTEGER, default=1, server_default='1'),
                   # Column("device", String(200), default='', server_default=''),
                   Column("weibo_url", String(300)),
                   Column("create_time", String(200)),
                   # Column("comment_crawled", INTEGER, default=0, server_default='0'),
                   # Column("repost_crawled", INTEGER, default=0, server_default='0'),
                   )

weixin_data = Table('weixin_data', metadata,
                   Column("id", INTEGER, primary_key=True, autoincrement=True),
                   Column("weixin_id", String(200),default='', server_default=''),
                   Column("weixin_cont", String(6000), default='', server_default=''),
                   Column("weixin_title", String(200), default='', server_default=''),
#contentcreated, created_content_username, keyword, admin_id,
                   Column("weixin_created", String(200), default='', server_default=''),
                   Column("weixin_created_name", String(200), default='', server_default=''),
                   Column("weixin_keyword", String(200), default='', server_default=''),
                   Column("admin_id", String(200), default='', server_default=''),
                   )